Tabela ttDRGVerificationEvents

Definicja tabeli ttDRGVerificationEvents

Name

ttDRGVerificationEvents

Code

ttDRGVerificationEvents

Comment

Lista wizyt które maja zostac zweryfikowane w ramach uruchomienia funkcji 'Kontrola grup AOS'
Oracle GLOBAL TEMPORARY TABLE ... ON COMMIT PRESERVE ROWS


Lista kolumn tabeli ttDRGVerificationEvents

Name

Code

EventID

EventID

StartDT

StartDT

StopDT

StopDT

EpisodeID

EpisodeID

OrgUnitID

OrgUnitID

Pat_PersonID

Pat_PersonID

AdmissionModeID

AdmissionModeID

VisitTypeID

VisitTypeID


Kolumna EventID tabeli ttDRGVerificationEvents

Definicja kolumny EventID tabeli ttDRGVerificationEvents

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ttDRGVerificationEvents

Definicja kolumny StartDT tabeli ttDRGVerificationEvents

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ttDRGVerificationEvents

Definicja kolumny StopDT tabeli ttDRGVerificationEvents

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna EpisodeID tabeli ttDRGVerificationEvents

Definicja kolumny EpisodeID tabeli ttDRGVerificationEvents

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitID tabeli ttDRGVerificationEvents

Definicja kolumny OrgUnitID tabeli ttDRGVerificationEvents

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Pat_PersonID tabeli ttDRGVerificationEvents

Definicja kolumny Pat_PersonID tabeli ttDRGVerificationEvents

Name

Pat_PersonID

Code

Pat_PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmissionModeID tabeli ttDRGVerificationEvents

Definicja kolumny AdmissionModeID tabeli ttDRGVerificationEvents

Name

AdmissionModeID

Code

AdmissionModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VisitTypeID tabeli ttDRGVerificationEvents

Definicja kolumny VisitTypeID tabeli ttDRGVerificationEvents

Name

VisitTypeID

Code

VisitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment